package com.ruoyi.system.service.impl;

import cn.hutool.core.util.ObjectUtil;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
import com.github.yulichang.wrapper.MPJLambdaWrapper;
import com.ruoyi.common.annotation.DataScope;
import com.ruoyi.common.constant.UserConstants;
import com.ruoyi.common.core.domain.TreeSelect;
import com.ruoyi.common.core.domain.entity.SysDept;
import com.ruoyi.common.core.domain.entity.SysRole;
import com.ruoyi.common.core.domain.entity.SysUser;
import com.ruoyi.common.core.text.Convert;
import com.ruoyi.common.exception.ServiceException;
import com.ruoyi.common.utils.SecurityUtils;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.common.utils.mybatisPlus.BaseServiceImpl;
import com.ruoyi.common.utils.spring.SpringUtils;
import com.ruoyi.system.domain.SysRoleDept;
import com.ruoyi.system.domain.SysUserRole;
import com.ruoyi.system.mapper.SysDeptMapper;
import com.ruoyi.system.mapper.SysRoleMapper;
import com.ruoyi.system.mapper.SysUserMapper;
import com.ruoyi.system.service.ISysDeptService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Iterator;
import java.util.List;
import java.util.stream.Collectors;

/**
 * 部门管理 服务实现
 * 
 * @author ruoyi
 */
@Service
public class SysDeptServiceImpl extends BaseServiceImpl<SysDeptMapper, SysDept> implements ISysDeptService
{
    @Autowired
    private SysDeptMapper deptMapper;

    @Autowired
    private SysUserMapper userMapper;

    @Autowired
    private SysRoleMapper roleMapper;

    /**
     * 查询部门管理数据
     * 
     * @param dept 部门信息
     * @return 部门信息集合
     */
    @Override
    @DataScope(deptAlias = "d")
    public List<SysDept> selectDeptList(SysDept dept)
    {
        // 构建查询条件
        LambdaQueryWrapper<SysDept> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.like(ObjectUtil.isNotEmpty(dept.getDeptName()),SysDept::getDeptName, dept.getDeptName());
        queryWrapper.eq(ObjectUtil.isNotEmpty(dept.getStatus()),SysDept::getStatus, dept.getStatus());
        queryWrapper.eq(ObjectUtil.isNotEmpty(dept.getDeptId()) && dept.getDeptId()!= 0,SysDept::getDeptId, dept.getDeptId());
        queryWrapper.eq(ObjectUtil.isNotEmpty(dept.getParentId()) && dept.getParentId()!= 0,SysDept::getParentId, dept.getParentId());
        if(ObjectUtil.isNotEmpty(dept.getParams()) && ObjectUtil.isNotEmpty(dept.getParams().get("dataScope"))){
            String dataScope = dept.getParams().get("dataScope").toString();
            //替换单表查询的 前缀
            queryWrapper.apply(dataScope.replace("d.", " "));
        }
        queryWrapper.orderByAsc(SysDept::getParentId).orderByAsc(SysDept::getOrderNum);
        // 执行查询并返回结果
        return deptMapper.selectList(queryWrapper);
    }

    /**
     * 查询部门树结构信息
     * 
     * @param dept 部门信息
     * @return 部门树信息集合
     */
    @Override
    public List<TreeSelect> selectDeptTreeList(SysDept dept)
    {
        List<SysDept> depts = SpringUtils.getAopProxy(this).selectDeptList(dept);
        return buildDeptTreeSelect(depts);
    }

    /**
     * 构建前端所需要树结构
     * 
     * @param depts 部门列表
     * @return 树结构列表
     */
    @Override
    public List<SysDept> buildDeptTree(List<SysDept> depts)
    {
        List<SysDept> returnList = new ArrayList<SysDept>();
        List<Long> tempList = depts.stream().map(SysDept::getDeptId).collect(Collectors.toList());
        for (SysDept dept : depts)
        {
            // 如果是顶级节点, 遍历该父节点的所有子节点
            if (!tempList.contains(dept.getParentId()))
            {
                recursionFn(depts, dept);
                returnList.add(dept);
            }
        }
        if (returnList.isEmpty())
        {
            returnList = depts;
        }
        return returnList;
    }

    /**
     * 构建前端所需要下拉树结构
     * 
     * @param depts 部门列表
     * @return 下拉树结构列表
     */
    @Override
    public List<TreeSelect> buildDeptTreeSelect(List<SysDept> depts)
    {
        List<SysDept> deptTrees = buildDeptTree(depts);
        return deptTrees.stream().map(TreeSelect::new).collect(Collectors.toList());
    }

    /**
     * 根据角色ID查询部门树信息
     * 
     * @param roleId 角色ID
     * @return 选中部门列表
     */
    @Override
    public List<Long> selectDeptListByRoleId(Long roleId)
    {
//        SysRole role = roleMapper.selectRoleById(roleId);
        MPJLambdaWrapper<SysRole> wrapper = new MPJLambdaWrapper<SysRole>()
                .selectAll(SysRole.class)
                .distinct()
                .leftJoin(SysUserRole.class, SysUserRole::getRoleId, SysRole::getRoleId)
                .leftJoin(SysUser.class, SysUser::getUserId, SysUserRole::getUserId)
                .leftJoin(SysDept.class, SysDept::getDeptId, SysUser::getDeptId)
                .eq(SysRole::getRoleId, roleId);
        SysRole role =  roleMapper.selectJoinOne(SysRole.class, wrapper);

        // 构建多表联查条件
        MPJLambdaWrapper<SysDept> wrapperTwo = new MPJLambdaWrapper<SysDept>()
                .select(SysDept::getDeptId,SysDept::getParentId,SysDept::getOrderNum)
                .distinct()
                .leftJoin(SysRoleDept.class, SysRoleDept::getDeptId, SysDept::getDeptId)
                .eq(SysRoleDept::getRoleId, roleId);
        if (role.isDeptCheckStrictly()) {
            MPJLambdaWrapper<SysDept> notIn = new MPJLambdaWrapper<SysDept>()
                    .select(SysDept::getParentId)
                    .innerJoin(SysRoleDept.class, SysRoleDept::getDeptId, SysDept::getDeptId)
                    .eq(SysRoleDept::getRoleId, roleId);
            List<SysDept> sysDepts = deptMapper.selectJoinList(SysDept.class, notIn);
            wrapperTwo.notIn(!sysDepts.isEmpty(),SysDept::getDeptId,sysDepts.stream().map(SysDept::getParentId).collect(Collectors.toList()));
        }

        // 添加排序规则
        wrapperTwo.orderByAsc(SysDept::getParentId).orderByAsc(SysDept::getOrderNum);
// 执行查询并返回结果
        List<SysDept> sysDepts = deptMapper.selectJoinList(SysDept.class, wrapperTwo);
        return sysDepts.stream().map(SysDept::getDeptId).collect(Collectors.toList());
//        return deptMapper.selectDeptListByRoleId(roleId, role.isDeptCheckStrictly());
    }

    /**
     * 根据部门ID查询信息
     * 
     * @param deptId 部门ID
     * @return 部门信息
     */
    @Override
    public SysDept selectDeptById(Long deptId)
    {
//        return deptMapper.selectDeptById(deptId);
        // 构建查询条件
        LambdaQueryWrapper<SysDept> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(SysDept::getDeptId, deptId);

        // 执行查询并返回结果
        SysDept dept = deptMapper.selectOne(queryWrapper);

        if (dept != null && dept.getParentId() != null) {
            // 查询父部门名称并设置到当前部门对象中
            SysDept parentDept = deptMapper.selectById(dept.getParentId());
            if (parentDept != null) {
                dept.setParentName(parentDept.getDeptName());
            }
        }

        return dept;
    }

    /**
     * 根据ID查询所有子部门（正常状态）
     * 
     * @param deptId 部门ID
     * @return 子部门数
     */
    @Override
    public int selectNormalChildrenDeptById(Long deptId)
    {
//        return deptMapper.selectNormalChildrenDeptById(deptId);
        // 构建查询条件
        LambdaQueryWrapper<SysDept> queryWrapper = new LambdaQueryWrapper<>();
        // 动态构建类似于 FIND_IN_SET 的查询条件
        queryWrapper.eq(SysDept::getStatus, 0)
                .like(deptId!=0,SysDept::getAncestors, deptId);
        return deptMapper.selectCount(queryWrapper);
    }

    /**
     * 是否存在子节点
     * 
     * @param deptId 部门ID
     * @return 结果
     */
    @Override
    public boolean hasChildByDeptId(Long deptId)
    {
//        int result = deptMapper.hasChildByDeptId(deptId);
//        return result > 0;
        // 构建查询条件
        LambdaQueryWrapper<SysDept> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(SysDept::getParentId, deptId);

        // 执行查询并返回结果
        int count = deptMapper.selectCount(queryWrapper);
        return count > 0;
    }

    /**
     * 查询部门是否存在用户
     * 
     * @param deptId 部门ID
     * @return 结果 true 存在 false 不存在
     */
    @Override
    public boolean checkDeptExistUser(Long deptId)
    {
//        int result = deptMapper.checkDeptExistUser(deptId);
//        return result > 0;
        // 构建查询条件
        LambdaQueryWrapper<SysUser> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(SysUser::getDeptId, deptId);

        // 执行查询并返回结果
        int count = userMapper.selectCount(queryWrapper);
        return count > 0;
    }

    /**
     * 校验部门名称是否唯一
     * 
     * @param dept 部门信息
     * @return 结果
     */
    @Override
    public boolean checkDeptNameUnique(SysDept dept)
    {
        Long deptId = StringUtils.isNull(dept.getDeptId()) ? -1L : dept.getDeptId();
//        SysDept info = deptMapper.checkDeptNameUnique(dept.getDeptName(), dept.getParentId());
        // 构建查询条件
        LambdaQueryWrapper<SysDept> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(SysDept::getDeptName, dept.getDeptName())
                .eq(SysDept::getParentId, dept.getParentId());
        // 执行查询并返回结果
        SysDept info =  deptMapper.selectOne(queryWrapper);
        if (StringUtils.isNotNull(info) && info.getDeptId().longValue() != deptId.longValue())
        {
            return UserConstants.NOT_UNIQUE;
        }
        return UserConstants.UNIQUE;
    }

    /**
     * 校验部门是否有数据权限
     * 
     * @param deptId 部门id
     */
    @Override
    public void checkDeptDataScope(Long deptId)
    {
        if (!SysUser.isAdmin(SecurityUtils.getUserId()) && StringUtils.isNotNull(deptId))
        {
            SysDept dept = new SysDept();
            dept.setDeptId(deptId);
            List<SysDept> depts = SpringUtils.getAopProxy(this).selectDeptList(dept);
            if (StringUtils.isEmpty(depts))
            {
                throw new ServiceException("没有权限访问部门数据！");
            }
        }
    }

    /**
     * 新增保存部门信息
     * 
     * @param dept 部门信息
     * @return 结果
     */
    @Override
    public int insertDept(SysDept dept)
    {
        SysDept info = this.selectDeptById(dept.getParentId());
        // 如果父节点不为正常状态,则不允许新增子节点
        if (!UserConstants.DEPT_NORMAL.equals(info.getStatus()))
        {
            throw new ServiceException("部门停用，不允许新增");
        }
        dept.setAncestors(info.getAncestors() + "," + dept.getParentId());
        dept.setDelFlag("0");
        return deptMapper.insert(dept);
    }

    /**
     * 修改保存部门信息
     * 
     * @param dept 部门信息
     * @return 结果
     */
    @Override
    public int updateDept(SysDept dept)
    {
        SysDept newParentDept = this.selectDeptById(dept.getParentId());
        SysDept oldDept = this.selectDeptById(dept.getDeptId());
        if (StringUtils.isNotNull(newParentDept) && StringUtils.isNotNull(oldDept))
        {
            String newAncestors = newParentDept.getAncestors() + "," + newParentDept.getDeptId();
            String oldAncestors = oldDept.getAncestors();
            dept.setAncestors(newAncestors);
            updateDeptChildren(dept.getDeptId(), newAncestors, oldAncestors);
        }
        int result = deptMapper.updateById(dept);
        if (UserConstants.DEPT_NORMAL.equals(dept.getStatus()) && StringUtils.isNotEmpty(dept.getAncestors())
                && !StringUtils.equals("0", dept.getAncestors()))
        {
            // 如果该部门是启用状态，则启用该部门的所有上级部门
            updateParentDeptStatusNormal(dept);
        }
        return result;
    }

    /**
     * 修改该部门的父级部门状态
     * 
     * @param dept 当前部门
     */
    private void updateParentDeptStatusNormal(SysDept dept)
    {
        String ancestors = dept.getAncestors();
        Long[] deptIds = Convert.toLongArray(ancestors);
//        deptMapper.updateDeptStatusNormal(deptIds);
        // 构建更新条件
        LambdaUpdateWrapper<SysDept> updateWrapper = new LambdaUpdateWrapper<>();
        updateWrapper.in(SysDept::getDeptId, Arrays.asList(deptIds))
                .set(SysDept::getStatus, 0);

        // 执行更新操作
        deptMapper.update(null,updateWrapper);
    }

    /**
     * 修改子元素关系
     * 
     * @param deptId 被修改的部门ID
     * @param newAncestors 新的父ID集合
     * @param oldAncestors 旧的父ID集合
     */
    public void updateDeptChildren(Long deptId, String newAncestors, String oldAncestors)
    {
//        List<SysDept> children = deptMapper.selectChildrenDeptById(deptId);
        // 构建查询条件
        LambdaQueryWrapper<SysDept> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.like(deptId!=0,SysDept::getAncestors, String.valueOf(deptId));

        // 执行查询并返回结果
        List<SysDept> children =  deptMapper.selectList(queryWrapper);
        for (SysDept child : children)
        {
            child.setAncestors(child.getAncestors().replaceFirst(oldAncestors, newAncestors));
        }
        if (!children.isEmpty())
        {
            this.saveOrUpdateBatch(children);
//            deptMapper.updateDeptChildren(children);
        }
    }

    /**
     * 删除部门管理信息
     * 
     * @param deptId 部门ID
     * @return 结果
     */
    @Override
    public int deleteDeptById(Long deptId)
    {
//        return deptMapper.deleteDeptById(deptId);
        // 构建更新条件
        LambdaUpdateWrapper<SysDept> updateWrapper = new LambdaUpdateWrapper<>();
        updateWrapper.eq(SysDept::getDeptId, deptId)
                .set(SysDept::getDelFlag, "2")
                .set(SysDept::getStatus, 0);

        // 执行更新操作
        return deptMapper.update(null,updateWrapper);
    }

    @Override
    public List<SysDept> getDeptListByParentId(Long parentId) {
//        return deptMapper.getDeptListByParentId(parentId);
        // 构建查询条件
        LambdaQueryWrapper<SysDept> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.select(SysDept::getDeptId, SysDept::getDeptName);
        queryWrapper.eq(SysDept::getParentId, parentId);

        // 执行查询并返回结果
        return deptMapper.selectList(queryWrapper);
    }

    @Override
    public List<Long> getSubDeptIds(Long deptId) {
        List<Long> subDeptIds = new ArrayList<>();
        // 添加当前部门ID到结果列表
        subDeptIds.add(deptId);
        // 获取直接子部门
        List<SysDept> childDepts = deptMapper.selectList(new LambdaQueryWrapper<SysDept>().eq(SysDept::getParentId, deptId));
        if (childDepts != null && !childDepts.isEmpty()) {
            // 递归获取所有子部门ID
            for (SysDept childDept : childDepts) {
                subDeptIds.addAll(getSubDeptIds(childDept.getDeptId()));
            }
        }
        return subDeptIds;
    }

    /**
     * 递归列表
     */
    private void recursionFn(List<SysDept> list, SysDept t)
    {
        // 得到子节点列表
        List<SysDept> childList = getChildList(list, t);
        t.setChildren(childList);
        for (SysDept tChild : childList)
        {
            if (hasChild(list, tChild))
            {
                recursionFn(list, tChild);
            }
        }
    }

    /**
     * 得到子节点列表
     */
    private List<SysDept> getChildList(List<SysDept> list, SysDept t)
    {
        List<SysDept> tlist = new ArrayList<SysDept>();
        Iterator<SysDept> it = list.iterator();
        while (it.hasNext())
        {
            SysDept n = (SysDept) it.next();
            if (StringUtils.isNotNull(n.getParentId()) && n.getParentId().longValue() == t.getDeptId().longValue())
            {
                tlist.add(n);
            }
        }
        return tlist;
    }

    /**
     * 判断是否有子节点
     */
    private boolean hasChild(List<SysDept> list, SysDept t)
    {
        return getChildList(list, t).size() > 0;
    }
}
